2014-06-12 - 12808 - Service Request - QR Orders not cancelling units #US #EMEA #APAC #ProductionBreakFix #SDSupportOSS

2014-06-12 - 12808 - Service Request - QR Orders not cancelling units

Problem Summary

QR Orders not cancelling units

Admin Info


Purpose
 QR Orders not cancelling units
Requested by
 Daniel Brennan
Issue Date
 05/06/2014
Resolved by
 Surya Basa / Deepak Yasam
Resolved Date
 06/25/2014
Document Status
 Complete

Detailed Problem Description

(Include Screen Shots if required )
In some cases, open units are not being cancelled on quick replenishment orders. We believe there is stock inbound from a PO, and it's confirmed on the sales order. However, the goods receipt hasn't occurred, so it couldn't create a delivery for those items, but because it's confirmed stock on the order, it's not auto-rejecting.


Solution Analysis and Recommendations

(Include Screen Shots if required)
The following observations were made in the investigation -
1. For Quick Replenishment orders (ZQR document type), delivery is created automatically for the confirmed items on the sales order and the unconfirmed/J0 rejected items are rejected with Z9 rejection on save. This logic is maintained in the user exit MV45AFZZ.
2. The scope of check is modified for QR orders where in Z2 availability check is changed to Z4 and Z3 is changed to Z5 via user exit MV45AFZZ. While Z2/Z3 consider incoming PO's; Z4/Z5 don't consider incoming PO's as the QR orders conform to Fill & Kill situation and also only delivery is allowed per order. This logic has also be coded in the exit.
3. In the above scenario, though the PO option is not flagged in the scope of check, system confirms the order quantity on the sales orders taking into consideration the incoming PO's that are not actually receipted yet. This is causing two issues - one- the confirmed quantities cannot be delivered as there's no stock and two-the undelivered items are not auto rejected.

Recommendation:
The issue was requested to be escalated to SAP as it was a standard process and any of user exit custom code was not found to cause any issue. A write up was provided with the details of the issue and relevant examples were provided from NECNED environment.
ATP Issue.docx


Resolution

SAP recommended implementing OSS note (1741607) to fix the issue. The note was implemented in NECNED and tests were carried out to check the scope of check for standard sales order process as well as for Quick Replenishment scenario. No issues were observed in the tests and results were as expected.
AVC PO's_Rush Orders_Quick Replenishment Orders_0001741607.pdf

Following test scenarios are tested in NECNED300.
S.No
 Availability Check and Procurement type
 Test Scenario
 Expected Result
 Actual Result
 Documents
 P/F
1
 Z2 availability check with procurement type E
 Step-1: Create PO for material 10017602 with quantity 10 EA for size 612 and delivery date 06/12/2014
Step-2: Create SO with document type ZQR for item 10017602 for quantity 10 EA with requested delivery date 06/12/2014
 For ZQR as per the logic ,the availability check Z2 will be converted to Z4 and PO stock is excluded during the ATP check .So the ordered qty should be rejected with J0 initially while creating the SO and after saving J0 should be changed to Z9
 The ordered qty is rejected with J0 initially while creating the SO and after saving J0 should be changed to Z9
 PO - 4600006936
SO - 67070
 P
2
 Z2 availability check with procurement type E
 Step-1: Create PO for material 10017602 with quantity 10 EA for size 700 and delivery date 06/12/2014. MIGO the PO so that the batch stock is available
Step-2: Create SO with document type ZQR for item 10017602 for quantity 10 EA with requested delivery date 06/12/2014
 For ZQR as per the logic ,the availability check Z2 will be converted to Z4 and batch stock is considered during the ATP check .So the ordered qty should be confirmed on the requested delivery date ie., 06/12/2014 and auto delivery is craeted.
 The ordered qty is confirmed on the requested delivery date ie., 06/12/2014 and auto delivery is craeted.
 PO - 4600006938
SO - 67072
Del - 80011253
 P
3
 Z2 availability check with procurement type E
 Create SO with document type ZOR for item 10017602 ,size 658 for quantity 10 EA with requested delivery date 06/12/2014
 As there is no PO or batch stock available and for ZOR orders both PO/batch stock will be considered for ATP check,the ordered qty should be confirmed by considering RLT time and propose a delivery date.
 The ordered qty is confirmed by considering RLT time (15 days and procurement type E) and proposed a delivery date as 07/03/2014 (only work days)
 SO - 67074
 P
4
 Z2 availability check with procurement type E
 Step-1: Create PO for material 10017602 with quantity 10 EA for size 812 and delivery date 06/12/2014
Step-2: Create SO with document type ZOR for item 10017602 for quantity 10 EA with requested delivery date 06/12/2014
 As there is PO stock available and for ZOR orders both PO/batch stock will be considered for ATP check,the ordered qty should be confirmed on requested delivery date ie., 06/12/2014
 The ordered qty is confirmed on requested delivery date ie., 06/12/2014
 PO - 4600006936
SO - 67076
 P
5
 Z3 availability check with procurement type E
 Step-1: Create PO for material 10017603 with quantity 10 EA for size 634 and delivery date 06/12/2014
Step-2: Create SO with document type ZQR for item 10017603 for quantity 10 EA with requested delivery date 06/12/2014
 For ZQR as per the logic , the availability check Z3 will be converted to Z5 and PO stock is excluded during the ATP check .So the ordered qty should be rejected with J0 initially while creating the SO and after saving J0 should be changed to Z9
 The ordered qty is rejected with J0 initially while creating the SO and after saving J0 should be changed to Z9
 PO - 4600006937
SO - 67071
 P
6
 Z3 availability check with procurement type E
 Step-1: Create PO for material 10017603 with quantity 10 EA for size 700 and delivery date 06/12/2014. MIGO the PO so that the batch stock is available
Step-2: Create SO with document type ZQR for item 10017603 for quantity 10 EA with requested delivery date 06/12/2014
 For ZQR as per the logic , the availability check Z3 will be converted to Z5 and batch stock is considered during the ATP check .So the ordered qty should be confirmed on the requested delivery date ie., 06/12/2014 and auto delivery is created.
 The ordered qty is confirmed on the requested delivery date ie., 06/12/2014 and auto delivery is craeted.
 PO - 4600006939
SO - 67073
Del - 80011250
 P
7
 Z3 availability check with procurement type E
 Create SO with document type ZOR for item 10017603 ,size 718 for quantity 10 EA with requested delivery date 06/12/2014
 As there is no PO or batch stock available and for ZOR orders ,the ordered qty is rejected with J0.
 The ordered qty is rejected with J0 .
 SO - 67075
 P
8
 Z3 availability check with procurement type E
 Step-1: Create PO for material 10017603 with quantity 10 EA for size 812 and delivery date 06/12/2014
Step-2: Create SO with document type ZOR for item 10017603 for quantity 10 EA with requested delivery date 06/12/2014
 As there is PO stock available and for ZOR orders both PO/batch stock will be considered for ATP check,the ordered qty should be confirmed on requested delivery date ie., 06/12/2014
 The ordered qty is confirmed on requested delivery date ie., 06/12/2014
 PO - 4600006941
SO - 67077
 P
9
 Z2 availability check with procurement type F
 Step-1: Create PO for material 10017605 with quantity 10 EA for size 700 and delivery date 07/14/2014
Step-2:Create SO with document type ZOR for item 10017605 and sizes 638,700 with quantity 10 EA each and requested delivery date 06/12/2014
 The size 700 with PO stock and the size 638 without any stock,both should be confirmed by considering the planned delivery time of 30 days and proposed delivery date of 07/14/2014.
 The ordered qty is confirmed by considering the planned delivery time of 30 days and proposed delivery date of 07/14/2014.
 PO - 4600006942
SO -67078
 P
10
 Z3 availability check with procurement type F
 Step-1: Create PO for material 10017606 with quantity 10 EA for size 700 and delivery date 07/14/214
Step-2:Create SO with document type ZOR for item 10017606 and sizes 612,700 with quantity 10 EA each and requested delivery date 06/12/2014
 The size 700 should be confirmed on the incoming PO date ie., 07/14/2014 and the size 612 should be rejected with J0 as there is no stock.
 The size 700 is confirmed on 07/14/2014 and size 612 is rejected with J0.
 PO - 4600006942
SO -67082
 P
11
 Z2 availability check with procurement type X
 Step-1: Create PO for material 10017608 with quantity 10 EA for size 700 and delivery date 06/12/2014
Step-2:Create SO with document type ZOR for item 10017608 and sizes 638,700 with quantity 10 EA each and requested delivery date 06/12/2014
 The size 700 with PO stock is confirmed on the requested delivery date and the size 638 without any stock should be confirmed by considering the RLT of 30 days and proposed delivery date 07/07/2014
 The size 700 is confirmed on 06/13/2014 and size 638 is confirmed on 07/07/2014 by considering 30 days of RLT.
 PO - 4600006942
SO -67080
 P
12
 Z3 availability check with procurement type X
 Step-1: Create PO for material 10017609 with quantity 10 EA for size 700 and delivery date 08/01/2014
Step-2:Create SO with document type ZOR for item 10017609 and sizes 638,700 with quantity 10 EA each and requested delivery date 06/12/2014
 The size 700 with PO stock is confirmed on the incoming PO date ie., 08/01/2014 and the size 632 should be rejected with J0 as there is no stock.
 The size 700 is confirmed on 08/01/2014 and size 638 is rejected with J0.
 PO - 4600006942
SO -67081
 P
Following test scenarios are tested in NECNEQ100.
S.No
 Availability Check and Procurement type
 Test Scenario
 Expected Result
 Actual Result
 Documents
 P/F
1
 Z2 availability check with procurement type E
 Step-1: Create PO for material 10028833 with quantity 10 EA for size 678 and delivery date 07/20/2014
 For ZQR as per the logic ,the availability check Z2 will be converted to Z4 and PO stock is excluded during the ATP check .So the ordered qty should be rejected with J0 initially while creating the SO and after saving J0 should be changed to Z9
 The ordered qty is rejected with J0 initially while creating the SO and after saving J0 should be changed to Z9
 PO - 4500074379
 P
Step-2: Create SO with document type ZQR for item 10028833 for quantity 10 EA with requested delivery date 07/20/2014
 SO - 1335639
2
 Z2 availability check with procurement type E
 Step-1: Create PO for material 10028833 with quantity 10 EA for size 700 and delivery date 07/20/2014. MIGO the PO so that the batch stock is available
 For ZQR as per the logic ,the availability check Z2 will be converted to Z4 and batch stock is considered during the ATP check .So the ordered qty should be confirmed on the requested delivery date ie., 07/20/2014 and auto delivery is created.
 The ordered qty is confirmed on the requested delivery date ie., 07/20/2014 and auto delivery is created.
 PO - 4500074382
 P
Step-2: Create SO with document type ZQR for item 10017602 for quantity 10 EA with requested delivery date 07/20/2014
 SO - 1335641

Del - 81420788
3
 Z2 availability check with procurement type E
 Create SO with document type ZOR for item 10028833 ,size 658 for quantity 10 EA with requested delivery date 07/20/2014
 As there is no PO or batch stock available and for ZOR orders both PO/batch stock will be considered for ATP check,the ordered qty should be confirmed by considering RLT time and propose a delivery date.
 The ordered qty is confirmed by considering RLT time (60 days and procurement type E) and proposed a delivery date as 09/26/2014 (only work days)
 SO - 1335642
 P
4
 Z2 availability check with procurement type E
 Step-1: Create PO for material 10028833 with quantity 10 EA for size 818 and delivery date 07/20/2014
 As there is PO stock available and for ZOR orders both PO/batch stock will be considered for ATP check,the ordered qty should be confirmed on requested delivery date ie., 07/20/2014
 The ordered qty is confirmed on requested delivery date ie., 07/25/2014 considering GR time on the material and the pick pack time maintained on the shipping point.
 PO - 4500074383
 P
Step-2: Create SO with document type ZOR for item 10028833 for quantity 10 EA with requested delivery date 07/20/2014
 SO - 1335647
5
 Z3 availability check with procurement type E
 Step-1: Create PO for material 10028835 with quantity 10 EA for size 634 and delivery date 07/21/2014
 For ZQR as per the logic , the availability check Z3 will be converted to Z5 and PO stock is excluded during the ATP check .So the ordered qty should be rejected with J0 initially while creating the SO and after saving J0 should be changed to Z9
 The ordered qty is rejected with J0 initially while creating the SO and after saving J0 should be changed to Z9
 PO - 4500074388
 P
Step-2: Create SO with document type ZQR for item 10017603 for quantity 10 EA with requested delivery date 07/21/2014
 SO - 1335648
6
 Z3 availability check with procurement type E
 Step-1: Create PO for material 10028835 with quantity 10 EA for size 700 and delivery date 07/21/2014. MIGO the PO so that the batch stock is available
 For ZQR as per the logic , the availability check Z3 will be converted to Z5 and batch stock is considered during the ATP check .So the ordered qty should be confirmed on the requested delivery date ie., 07/21/2014 and auto delivery is created.
 The ordered qty is confirmed on the requested delivery date i.e., 07/21/2014 and auto delivery is created.
 PO - 4500074389
 P
Step-2: Create SO with document type ZQR for item 10028726 for quantity 10 EA with requested delivery date 07/21/2014
 SO - 1335651

Del - 80011250
7
 Z3 availability check with procurement type E
 Create SO with document type ZOR for item 10028835 ,size 718 for quantity 10 EA with requested delivery date 07/20/2014
 As there is no PO or batch stock available and for ZOR orders ,the ordered qty is rejected with J0.
 The ordered qty is rejected with J0 .
 SO - 1335652
 P
8
 Z3 availability check with procurement type E
 Step-1: Create PO for material 10083991 with quantity 10 EA for size 634 and delivery date 07/21/2014
 As there is PO stock available and for ZOR orders both PO/batch stock will be considered for ATP check,the ordered qty should be confirmed on requested delivery date ie., 07/21/2014
 The ordered qty is confirmed on requested delivery date i.e., 07/23/2014 considering the pick/pack time on the shipping point
 PO - 4500074390
 P
Step-2: Create SO with document type ZOR for item 10083991 for quantity 10 EA with requested delivery date 07/21/2014
 SO - 1335653
9
 Z2 availability check with procurement type F
 Step-1: Create PO for material 10014737 with quantity 10 EA for size 605 and delivery date 07/21/2014
 The size 605 with PO stock and the size 600 without any stock,both should be confirmed by considering the planned delivery time of 91 days and proposed delivery date of 07/21/2014.
 The ordered qty for size 600 is confirmed by considering the planned delivery time of 91 days and for size 605 as 07/30/2014 considering GR time and pick/pack time.
 PO - 4500074391
 P
Step-2:Create SO with document type ZOR for item 10014737 and sizes 600, 605 with quantity 10 EA each and requested delivery date 07/21/2014
 SO -1335654
10
 Z3 availability check with procurement type F
 Step-1: Create PO for material 10000131 with quantity 10 EA for size 595 and delivery date 07/21/2014
 The size 595 should be confirmed on the incoming PO date ie., 07/21/2014 and the size 590 should be rejected with J0 as there is no stock.
 The size 595 is confirmed on 07/21/2014 and size 590 is rejected with J0.
 PO - 4500074393
 P
Step-2:Create SO with document type ZOR for item 10000131 and sizes 595,590 with quantity 10 EA each and requested delivery date 07/21/2014
 SO -1335655
11
 Z2 availability check with procurement type X
 Step-1: Create PO for material 10000208 with quantity 10 EA for size 678 and delivery date 07/21/2014
 The size 678 with PO stock should be confirmed on the requested delivery date and the size 634 without any stock should be confirmed by considering the RLT+GR+pick/pack days and proposed delivery date 08/27/2014
 The size 678 is confirmed on 07/28/2014 and size 634 is confirmed on 08/27/2014 by considering 42 days of RLT and 3 days of GR time and 2 days of pick/pack time.
 PO - 4500074394
 P
Step-2:Create SO with document type ZOR for item 10017608 and sizes 678,634 with quantity 10 EA each and requested delivery date 07/21/2014
 SO -1335656
12
 Z3 availability check with procurement type X
 Step-1: Create PO for material 10002059 with quantity 10 EA for size 700 and delivery date 08/01/2014
 The size 700 with PO stock is confirmed on the incoming PO date ie., 08/01/2014 and the size 634 should be rejected with J0 as there is no stock.
 The size 700 is confirmed on 08/08/2014 considering GR time and pick/pack time and size 634 is rejected with J0.
 PO - 4500074395
 P
Step-2:Create SO with document type ZOR for item 10017609 and sizes 634,700 with quantity 10 EA each and requested delivery date 08/01/2014
 SO -1335657

Release Information

Provide link here to Release Notes if Technical Objects were changed
None